3 visuals for webpage
This code will help produce the three visuals that are going to be a
part of each equity tracker indicator webpage: regional map (tract
level) of most recent data, chart of the most recent data, chart of
trends over time.
If the indicator is available through a tract-level data
set. Getting the data to a workable version may require some
data transformation. To explore, clean, transform, and generate a final
data set, please use the data-gen-tract-template. This script
will generate an .rda for the map and an .rda for the charts. These data
sets will be loaded in before the data visualization code.
Indicator Explanation
[Please include the following for a general, layperson audience: 1-2
sentences explaining what your indicator is/measures, what it says about
people’s life outcomes; 1 sentence describing why it is useful/relevant
in the indicator’s theme]
1. Map of most recent data
To map data in this form, there should be a value corresponding to
each census tract. Depending on the year or source of the data, this
could be about 700 rows for data at the 2010 census tract resolution, or
about 900 rows for data at the 2020 census tract resolution.
Create Visual
Sources: U.S. Census Bureau, American Community Survey (ACS) 2021
5-Year Estimates; U.S. Census Bureau, Geography Division 2020 TIGER/Line
Shapefiles
Data call outs
- 3.40 miles: The region’s average distance to high capacity transit
(HCT)
- 31.99 miles: The census tract with the farthest average distance to
HCT is in Snohomish County
- 0.06 miles: The census tract with the shortest average distance to
HCT is in King County
Insights & Analysis
- King County has the lowest average distance to HCT (2.49 miles),
followed by Kitsap (4.34 miles), Pierce (4.37 miles), and Snohomish
(4.59 miles)
- Of the 10 census tracts with the farthest distance to HCT (all of
which are over 18 miles), 4 are located in Snohomish County, 4 are in
King, and 1 is in Pierce
- There are 283 tracts in the region with an average distance to HCT
less than one mile: 71% in King, 19% in Snohomish, 7% in Pierce, and 2%
in Kitsap
2. Facet of most recent data
Create Visual
Distance to High Capacity Transit
The weighted distance in miles to high capacity transit (HCT) stations
in 2021
GTFS (General Transit Feed Specification), U.S. Census Bureau, American
Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)
Data call outs
- 3.5 miles: The average regional distance to HCT for people living in
census tracts with the highest concentration of people of color,
compared to 7.9 miles in census tracts with the lowest concentrations of
people of color
- 4.3 miles: Those living in census tracts with the highest
concentration of low income households are 4.3 miles closer to HCT than
those living in census tracts with the lowest concentration
- 3.8 miles: Those living in census tracts with the highest
concentration of households with youth are 3.8 miles farther from HCT
than those living in census tracts with the lowest concentration
Insights & Analysis
- The difference in distance to HCT between those living in census
tracts with a high and low concentration of limited English proficient
households is greatest in Snohomish (5.1 miles), Pierce (3.9 miles),
King (2.9 miles), and Kitsap (1.2 miles)
- There is no noticeable relationship between distance to HCT and and
living in census tracts with high and low concentrations of people with
disabilities
- When comparing the life expectancy of those living in census tracts
with the highest and lowest concentrations of households with children
under 18 years old, life expectancy is slightly higher in King County
(2.9 years) and Snohomish County (1.4 years) and much lower in Kitsap
County (-22.4 years) and Pierce County (-9.3 years)
3. Facet of trend data
Create Visual
Distance to High Capacity Transit
The weighted distance in miles to high capacity transit (HCT) stations
in 2021
GTFS (General Transit Feed Specification), U.S. Census Bureau, American
Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)
Data call outs
- 3.9 years: The regional life expectancy gap between census tracts
with the highest and lowest concentrations of people of color in 2010, a
15.8% smaller gap than in 2020
- 293%: The increase in the regional life expectancy gap between
census tracts with the highest and lowest concentrations of households
below 200% of the poverty line between 2010 and 2020
- 71.5 years: The 2020 regional life expectancy in tracts with the
highest concentrations of households below 200% of the poverty line, 7
years fewer than the regional average (78.8) and 9 years fewer than the
regional median (80.9)
Insights & Analysis
- Snohomish County is the only county in the region where the life
expectancy of the census tracts with the highest concentration of people
of color exceeds the life expectancy of the census tracts with the
lowest concentration of people of color, a trend consistent over the
past decade
- The life expectancy gaps between census tracts with the highest and
lowest concentration of households below 200% of the poverty line
increased in all counties between 2010 and 2020, with the largest gap
change in Pierce County (7.2 years) and the smallest gap change in
Kitsap County (1.6 years)
- The 2020 life expectancy of those living in the census tracts with
the highest concentrations of households with limited English
proficiency is shortest in Pierce County (70.4 years), compared to King
County () and Snohomish County (80.5 years)